/*
 Navicat Premium Data Transfer

 Source Server         : dn07
 Source Server Type    : MySQL
 Source Server Version : 80011
 Source Host           : dn07:3306
 Source Schema         : dldsj

 Target Server Type    : MySQL
 Target Server Version : 80011
 File Encoding         : 65001

 Date: 10/05/2019 17:48:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mr_task_monitor_copy1
-- ----------------------------
DROP TABLE IF EXISTS `mr_task_monitor_copy1`;
CREATE TABLE `mr_task_monitor_copy1` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `application_type` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `queue` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `state` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `final_status` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `progress` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `tracking_ui` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `tracking_url` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `cluster_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `started_time` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `finished_time` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `elapsed_time` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `am_container_logs` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `am_host_http_address` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `allocated_mb` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `allocated_vcores` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `running_containers` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of mr_task_monitor_copy1
-- ----------------------------
BEGIN;
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1552978847592_0049', 'root', 'ODPairDetectionVehicle1552996522898', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1552978847592_0049/', '1552978847592', '1552996528588', '1552996548727', '20139', 'http://nn02:8042/node/containerlogs/container_1552978847592_0049_01_000001/root', 'nn02:8042', '-1', '-1', '-1');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1552978847592_0065', 'root', 'Edit1553046844064', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1552978847592_0065/', '1552978847592', '1553046848455', '1553046904209', '55754', 'http://dn06:8042/node/containerlogs/container_1552978847592_0065_01_000001/root', 'dn06:8042', '-1', '-1', '-1');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1552978847592_0066', 'root', 'BKmeans1553046883202', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1552978847592_0066/', '1552978847592', '1553046888937', '1553046951911', '62974', 'http://nn02:8042/node/containerlogs/container_1552978847592_0066_01_000001/root', 'nn02:8042', '23040', '5', '5');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0134', 'root', 'DTW1554107787477', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0134/', '1553049306827', '1554107792198', '1554107814736', '22538', 'http://nn01:8042/node/containerlogs/container_1553049306827_0134_01_000001/root', 'nn01:8042', '-1', '-1', '-1');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0234', 'root', 'DTW1554900793169', 'SPARK', 'root.users.root', 'FINISHED', 'FAILED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0234/', '1553049306827', '1554900803283', '1554962886824', '62083541', 'http://dn07:8042/node/containerlogs/container_1553049306827_0234_02_000002/root', 'dn07:8042', '4608', '1', '1');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0235', 'root', 'ODPairDetectionVehicle1554900970544', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0235/', '1553049306827', '1554900980579', '1554962938051', '61957472', 'http://dn04:8042/node/containerlogs/container_1553049306827_0235_01_000003/root', 'dn04:8042', '9216', '2', '2');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0236', 'root', 'ODPairDetectionVehicleTest1554952203228', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0236/', '1553049306827', '1554952211825', '1554962972415', '10760590', 'http://dn02:8042/node/containerlogs/container_1553049306827_0236_01_000001/root', 'dn02:8042', '13824', '3', '3');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0293', 'root', 'DataCleaning1555075049640', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0293/', '1553049306827', '1555075053951', '1555075089247', '35296', 'http://dn05:8042/node/containerlogs/container_1553049306827_0293_01_000001/root', 'dn05:8042', '-1', '-1', '-1');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0294', 'root', 'SpatialAdjacency1555076495817', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0294/', '1553049306827', '1555076500124', '1555076542059', '41935', 'http://dn03:8042/node/containerlogs/container_1553049306827_0294_01_000001/root', 'dn03:8042', '-1', '-1', '-1');
INSERT INTO `mr_task_monitor_copy1` VALUES ('application_1553049306827_0295', 'root', 'TrajectoryReconstruction1555077120088', 'SPARK', 'root.users.root', 'FINISHED', 'SUCCEEDED', '100.0', 'History', 'http://nn02:8088/proxy/application_1553049306827_0295/', '1553049306827', '1555077124379', '1555078714088', '1589709', 'http://nn02:8042/node/containerlogs/container_1553049306827_0295_01_000001/root', 'nn02:8042', '-1', '-1', '-1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
